﻿CREATE TABLE [dbo].[Rates] (
    [RateId]          UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [InCurrencyId]    UNIQUEIDENTIFIER NOT NULL,
    [OutCurrencyId]   UNIQUEIDENTIFIER NOT NULL,
    [CountryId]       UNIQUEIDENTIFIER NOT NULL,
    [RangeDateFrom]   DATETIME         NOT NULL,
    [RangeDateTo]     DATETIME         NOT NULL,
    [OperationTypeId] UNIQUEIDENTIFIER NOT NULL,
    [Rate]            DECIMAL (18, 4)  NOT NULL,
    [InsertDate]      DATETIME         NULL,
    [UpdateDate]      DATETIME         NULL
);



